SUPPORT / SAMPLES & SAS NOTES
Problem Note 41038: Data items that are referenced by more than one label in a report might cause an error in SAS® Web Report Studio
 |  |  |  |  |
When the query cache is enabled, SAS Web Report Studio adds a data item to the query only once, even if the data item is used multiple times in the report. This action is taken for performance reasons. However, if the data item is identified by more than one label, then you might see the following error:
[a12844906598800.9734210923505455_2_0] Error Rendering the Report com.sas.iquery.metadata.expr.ResourceAwareStringExpression Root Cause: java.lang.ClassCastException: com.sas.iquery.metadata.expr.ResourceAwareStringExpression at com.sas.report.render.optimizer.util.ExpressionResolverUtil.resolveQualifiedColu mn(ExpressionResolverUtil.java:519) at com.sas.report.render.optimizer.util.ExpressionResolverUtil.resolveExpression(Ex pressionResolverUtil.java:145) .......
For example, a data item might be referenced by more than one label if it is used by itself and also in an expression for a calculated data item.
As a workaround, you can disable the query cache, as explained in Improving the Performance of SAS Web Report Studio.
Click the Hot Fix tab in this note to access the hot fix for this issue.
Operating System and Release Information
| Product Family | Product | System | Product Release | SAS Release | ||
| Reported | Fixed* | Reported | Fixed* | |||
| SAS System | SAS Web Report Studio | Microsoft® Windows® for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 |
| Microsoft Windows Server 2003 Datacenter Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Enterprise Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 Standard Edition | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2003 for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows Server 2008 for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Microsoft Windows XP Professional | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Windows Vista for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled AIX | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| 64-bit Enabled Solaris | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| HP-UX IPF | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Linux for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||
| Solaris for x64 | 4.2 | 4.31 | 9.2 TS2M0 | 9.3 TS1M0 | ||